package com.atguigu.gulimall.product.service.impl;

import com.atguigu.gulimall.product.entity.AttrEntity;
import com.atguigu.gulimall.product.service.AttrService;
import com.atguigu.gulimall.product.vo.AttrGroupWithAttrsVo;
import com.atguigu.gulimall.product.vo.SkuItemVo;
import com.atguigu.gulimall.product.vo.SpuItemAttrGroupVo;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.atguigu.common.utils.PageUtils;
import com.atguigu.common.utils.Query;

import com.atguigu.gulimall.product.dao.AttrGroupDao;
import com.atguigu.gulimall.product.entity.AttrGroupEntity;
import com.atguigu.gulimall.product.service.AttrGroupService;
import org.springframework.util.StringUtils;


@Service("attrGroupService")
public class AttrGroupServiceImpl extends ServiceImpl<AttrGroupDao, AttrGroupEntity> implements AttrGroupService {

    @Autowired
    AttrService attrService;

    @Override
    public PageUtils queryPage(Map<String, Object> params) {
        IPage<AttrGroupEntity> page = this.page(
                new Query<AttrGroupEntity>().getPage(params),
                new QueryWrapper<AttrGroupEntity>()
        );

        return new PageUtils(page);
    }

    @Override
    public PageUtils queryPage(Map<String, Object> params, Long catelogId) {
//        String key = (String) params.get("key");
//        //select * from pms_attr_group where catelog_id=? and (attr_group_id=key or attr_group_name like %key%)
//        QueryWrapper<AttrGroupEntity> wrapper = new QueryWrapper<AttrGroupEntity>();
//        if(!StringUtils.isEmpty(key)){
//            wrapper.and((obj)->{
//                obj.eq("attr_group_id",key).or().like("attr_group_name",key);
//            });
//        }
//
//        if( catelogId == 0){
//            IPage<AttrGroupEntity> page = this.page(new Query<AttrGroupEntity>().getPage(params),
//                    wrapper);
//            return new PageUtils(page);
//        }else {
//            wrapper.eq("catelog_id",catelogId);
//            IPage<AttrGroupEntity> page = this.page(new Query<AttrGroupEntity>().getPage(params),
//                    wrapper);
//            return new PageUtils(page);
//        }
        String key = (String) params.get("key");
        QueryWrapper<AttrGroupEntity> wrapper = new QueryWrapper<AttrGroupEntity>();
        if (!StringUtils.isEmpty(key)) {
            wrapper.and((obj) -> {
                obj.eq("attr_group_id", key).or().like("attr_group_name", key);
            });
        }

        if (catelogId == 0) {
            IPage<AttrGroupEntity> page = this.page(new Query<AttrGroupEntity>().getPage(params), new QueryWrapper<AttrGroupEntity>());
            return new PageUtils(page);
        } else {
            // select * from pms_attr_group where catelogId = ? and (attr_group_id = key or attr_group_name like %key%)
            wrapper.eq("catelog_id", catelogId);
            IPage<AttrGroupEntity> page = this.page(new Query<AttrGroupEntity>().getPage(params), wrapper);
            return new PageUtils(page);
        }
    }

    /**
     * 根据分类id查出所有的分组以及这些组里面的属性
     *
     * @param catelogId
     * @return
     */
    @Override
    public List<AttrGroupWithAttrsVo> getAttrGroupWithAttrsByCatelogId(Long catelogId) {
//            //com.atguigu.gulimall.product.vo
//        //1、查询分组信息
//        List<AttrGroupEntity> attrGroupEntities = this.list(new QueryWrapper<AttrGroupEntity>().eq("catelog_id", catelogId));
//
//        //2、查询所有属性
//        List<AttrGroupWithAttrsVo> collect = attrGroupEntities.stream().map(group -> {
//            AttrGroupWithAttrsVo attrsVo = new AttrGroupWithAttrsVo();
//            BeanUtils.copyProperties(group,attrsVo);
//            List<AttrEntity> attrs = attrService.getRelationAttr(attrsVo.getAttrGroupId());
//            attrsVo.setAttrs(attrs);
//            return attrsVo;
//        }).collect(Collectors.toList());
//
//        return collect;

        List<AttrGroupEntity> groupEntities = this.list(new QueryWrapper<AttrGroupEntity>().eq("catelog_id", catelogId));

//        查询所有的属性信息
        List<AttrGroupWithAttrsVo> collect = groupEntities.stream().map((group) -> {
            AttrGroupWithAttrsVo vo = new AttrGroupWithAttrsVo();
            BeanUtils.copyProperties(group, vo);
            List<AttrEntity> relationAttr = attrService.getRelationAttr(group.getAttrGroupId());
            vo.setAttrs(relationAttr);
            return vo;
        }).collect(Collectors.toList());
//        attrService.list(new QueryWrapper<AttrEntity>().in("attr_group_id",))
        return collect;
    }

    /**
     * 查出当前spu对应的所有属性分组的信息以及分组下所有属性对应的值
     *
     * SELECT
     * 	pag.attr_group_name,
     * 	pag.attr_group_id,
     * 	arr.attr_id,
     * 	pa.attr_name,
     * 	pa.attr_value
     * FROM
     * 	pms_attr_group pag
     * 	LEFT JOIN pms_attr_attr_group_relation aar on aar.attr_group_id = pag.attr_group_id
     * 	LEFT JOIN pms_attr pa on aar.attr_id = pa.attr_id
     * 	LEFT JOIN pms_product_attr_value pav on pav.attr_id = pa.attr_id
     *
     * where pag.catelog_id = 225 and pav.spu_id = 13;
     * @param spuId
     * @param catalogId
     * @return
     */
    @Override
    public List<SpuItemAttrGroupVo> getAttrGroupWithAttrsBySpuId(long spuId, long catalogId) {
        return baseMapper.getAttrGroupWithAttrsBySpuId(spuId,catalogId);
    }
}